Information Systems for

Emergency Services

Public Access to	Defibrillation	Registration and	Tracking Database

Prototype

User’s Guide

Program & Documentation Copyrighted © 2004 by Robert W. Austin

Program Released Under the General Public License

Documentation Released Under the GNU Free Documentation License

Copyright © 2004 by Robert W. Austin.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the appendix entitled "GNU Free Documentation License".

Table of Contents

Introduction	5

Installation	6

Single, Stand-Alone Computer System	6

Network Computer System	6

Update Table Links	7

Create a Desktop Shortcut	8

Running the Program for the First Time	9

Review Blank Application	9

Setup Database Fields	9

Security	9

Getting Started	10

The Switchboard	10

PAD Registration	10

Reports...	10

Database Setup...	10

License	10

Quit Program	10

PAD Registration Screen	11

Activating the PAD Registration Screen	11

The PAD Registration Screen - An Overview	11	Facility Name	12

Tabbed Dialog Box	12

New	12

Search	12

Delete	12

PAD Application	12

Close	12

Database Buttons	13

Go To First Record	13

Go To Previous Record	13

Go To Next Record	13

Go To Last Record	13

Create New Record	13

The PAD Registration Screen - Facility Information	14

The PAD Registration Screen - Hazard Information	15

The PAD Registration Screen - AED Information	16

AED Information	16

Electrode Information	16

The PAD Registration Screen - Program Coordinator Information	17

The PAD Registration Screen - Medical Director Information	18

Search for Existing Director	19

The PAD Application Screen - An Overview	20

Application Report Packages	21	Rejection Notice	21	Certification Package	21

The PAD Application Screen - Employees & Payment	23

Employees	23	Payment	23

Rejection Status - Missing Items	24

PAD Database Setup	25

Database Setup Switchboard	25

Manufacturers	25	AED Brands	26	Pad Brands	26	Facility Types	26	Hazards	26

Modifying the Program	27

Data Dictionary	27

Report Modifications	27

Security	27

Program Expansion	28

PAD Database Reports	29

Report Buttons	29

Facility Reports	29

Alphabetical Listing	29

Grouped by Manufacturer	30

Facility Hazards	30

Coordinator Listing	30

Medical Director Listing	30

AED Pad Reports	30	Program Reports	30

Status Report	30

Outstanding Applications	30

SourceForge.Net	31

Appendices	33

Appendix A: Glossary	34

Appendix B: Data Dictionary	39

Appendix C: General Public License	47

Appendix D: GNU Free Documentation License	53

Introduction

The Public Access Defibrillation (PAD) Program Registration database was designed to help track and report all those business and public access buildings where an Automated External Defibrillator (AED) is located. The program was developed first and foremost as a proof of concept, with the user of the program most likely a health care provider and not a computer programer. We have attempted to keep the program as simple as possible, while attempting to make sure that the possibility of data errors is reduced.

This guide will take you through the program, identifying the various section of the program. The guide will explain what each item does, and how various aspects of the program work together.

As with any new program there are sure to be problems, and we recognize that you may experience difficulties using the program. We ask that you notify the developers of the program when this occurs. As this is a prototype, it is being designed to prove a concept and may not be useful for day to day usage. Because it is a prototype, if there are changes that you would like to see made to the full version of the program, please let us know so that we can incorporate them.

It is assumed that the user has a basic understanding of the Windows® operating system, and is familiar with terms such as window, pop-up menu, right-click, mouse, etc. If you are not familiar with these terms and their usage, we would suggest that you study a generic Windows® user book and become familiar with the Windows® system prior to using this program.

The program was developed utilizing Microsoft® Access® 2000. The program is designed to be split into two parts, with the data tables residing on the agency server, while to front end (the part of the program with the forms and reports) resides on the local machine.

Installation

The prototype is an Access® 2000 database, and you must have Access® 2000 installed in order to use this prototype. The prototype is split into two separate parts;

a.	PadPrototype.mdb

This is the 'front end' of the database, and contains the forms, reports, queries, etc that are used by the program.

b.	d_PadPrototype.mdb

This is the 'back end' of the database, and contains the data tables.

The database can be installed on a single, 'stand-alone' computer or on multiple computers in a networked environment. The following sections will describe how to install the program in either environment.

Single, Stand-Alone, Computer System

When installing the program on a single computer, it is recommended that both files be installed into the same folder. For example, many users have their programs located in the “C:\Program Files” folder. To install your program in a similar style,

a.	Create a new folder “PAD” in the “C:\Program Files” folder.

b.	Copy both files (PadPrototype.mdb & d_PadPrototype.mdb) into the PAD folder.

Networked Computer System

When installing the program on multiple computers in a networked environment, the 'front end' program (PadPrototype.mdb) is installed on all of the workstations that will use the program. The 'back end' program (d_PadPrototype.mdb) is installed on a single server that all of the workstations can access.

On the workstations, it is common to have the 'front end' program located in the “C:\Program Files” folder. To install your program in a similar style,

a.	Create a new folder “PAD” in the “C:\Program Files” folder.

b.	Copy the file PadPrototype.mdb into the PAD folder.

On the server, create a folder to store the 'back end' program (d_PadPrototype.mdb). This may appear like the following; “w:\ems\data\pad data.” It is important that all of the workstations that have the front end program installed are able to read and write to this folder on the server.

Update the Table Links

Once the two program files have been copied to the proper folders, the next step is to let the 'front end' program know where the 'back end' data is located. This is accomplished through the Access® program's “Linked Table Manager.”

Begin by opening Access® 2000. When the opening file screen appears, it should have the “More Files...” line highlighted. If not, highlight this line then click “OK.” A file explorer screen will appear. Navigate to the folder that contains the front end file “PadPrototype.mdb,” hold down the 'SHIFT' key, and click OK. This will open the program file without executing the program's start-up routines.

Now go up to the menu bar and click on 'Tools' to 'Database Utilities' to 'Linked Table Manager.' This will open the link table manager screen.

Click on the 'Select All' button, and make sure the 'Always prompt for new location' box is checked. Now click on the 'OK' button.

A file explorer screen will appear asking you to select the new location of the table 'lkupAEDBrand.' Navigate to the folder that contains the program back end file d_PadPrototype.mdb. Highlight the file and click on the 'Open' button. The program should now update the remain tables with the new file location. When the task is complete, a message box stating “All selected linked tables were successfully refreshed” will appear. Click the 'OK' button and then click on the 'Close' button to close the Linked Table Manager screen.

You can also close out Access® at this time.

Create A Desktop Shortcut

Open the folder that contains the front end program 'PadPrototype.mdb.' Right-click on the file, and on the pop-up menu select 'Create Shortcut.' Drag the newly created shortcut to the desktop.

Installation Complete

This completes the installation of the PAD Tracking Database. Clicking on the shortcut on the desktop should open Access and start the PAD Tracking Database program.

Running the Program

for the First Time

To reduce the amount of frustration and to allow for an easier and quicker use of the program, it is recommended that the following procedures be performed before entering new PAD programs into the database.

Review Blank Application

It is also a good idea to print out and review the blank application. This will give you a good idea of the type of information the program will be asking for, and how that data is to be entered. It will also help you determine how to set up the database fields.

Setup Database Fields

There are five areas that should be completed prior to entering any PAD program applications. These five areas include;

a.	Manufacturers

This includes manufacturers of AEDs and AED pads

b.	AED Brands

This includes the various brands and models of AEDs.

c.	AED Pad Brands

This includes the various brands and models of AED pads.

d.	Facility Types

This would include the various types of facilities within your jurisdiction. You should also look at the sample facility types included.

e.	Hazard Types

This would include the various types of hazards you would expect to find within the facilities of your jurisdiction. You should also look at the sample hazard types included.

While it is not necessary to enter all of the information prior to entering new PAD programs, it will make the data entry process much smoother.

For a more detailed discussion of the PAD Database Setup, see page 25.

Security

If you know what type of computing the program is to be used, you can set up your security procedures before first running the program. If you are not sure how the program will be used, the security can be set up at a later time. However, it is not recommended that the program be used without some type of security function operational.

For a more detailed discussion of the Database Security, see Security on Page 27.

Getting Started

The program can be started by double clicking on the Pad Registration icon located on the desktop. You can also open the program by right-clicking on the icon, and then selecting ‘Open’ from the pop-up menu.

When the program begins to run, the splash screen will appear on the screen. The screen will be displayed for about 30 seconds while the program loads some utilities in the background. Once the program is ready to operate, the Main Switchboard screen will appear.

The Switchboard

The graphic to the right displays the Main Switchboard. Each of these items will be discussed in detail later in this manual. However, what follows is a brief overview of the areas that can be accessed from this switchboard.

PAD Registration

This button will take you to the heart of the program. The PAD Registration area is where all of the information on the facilities that have PAD programs are located. It also includes the link to the PAD Application.

Reports...

Clicking on this button will activate the Reports Switchboard. This is the area where the bulk of the reports are made available.

Database Setup...

This activates the setup switchboard, access items such as AED manufacturers, authorized users, etc.

License

This button will bring up a screen that will display the GNU General Public License and the GNU Free Documentation License.

Quit

The button in the lower right corner of the form allows you to exit the program. It will display a confirmation box prior to exiting. All data will saved upon exiting the program.

Pad Registration Screen

The PAD Registration Screen is the section of the program where you will probably spend most of your time. This is the screen where you will find the information on the facilities and groups that have PAD programs. This screen is also where you will access the PAD Application screen.

Activating the PAD Registration Screen

Start the program by double-clicking the PAD Program icon on the desktop. From the Main Switchboard, click on the ‘PAD Registration’ button.

There may be a delay as the database runs some background operations prior to displaying the PAD Registration Screen.

The PAD Registration Screen - An Overview

The PAD Registration Screen is divided into several areas. Each of these areas is described below.

Facility Name

At the top is a text box where the name of the facility is displayed. This will always be displayed to show the facility you are currently working with. It is a required field when entering a new facility into the database

Tabbed Dialog Box

The majority of the screen is occupied by a tabbed dialog box. There are five tabs consisting of Facility Info, Hazards, AED, Program Coordinator, and Medical Director. Clicking on one of these tabs will access the associated information. Each of the tabs will be discussed in detailed later in this manual.

New

The New button is used to add a new facility to the database. This is typically used when you receive a new application, and the facility is not in the database. Clicking on the button will clear the screen. Some fields will turn blue to indicate required fields.

Search

This button will bring up a dialog box allowing you to search all of the facilities currently in the database. The Search Dialog box and tips on searching through database records is discussed in detailed in the glossary section, beginning on page 36.

Delete

The Delete button will erase the current facility from the database. After clicking on the Delete button, a message box will appear to confirm that you wish to delete the facility and all information associated with that facility. Once a facility has been deleted, there is no way to go back and recover the lost information. Use this button cautiously.

PAD Application

When clicked, the PAD Application form for the current facility will be displayed. No other screens can be accessed while the Application form is visible. The PAD Application form is discussed in detailed later in this manual.

Close

This button will close the PAD Registration form. All information currently displayed will be saved to the database. The Main Switchboard should then be visible.

Before we get into more specifics of the various database fields, we need to review the small buttons located at the bottom left corner of the form. These buttons are very important, as they allow you to scroll through the database records quickly and easily.

Database Buttons

There are five database buttons located in the bottom left corner of the form. Their use is described below.

Go To First Record

When clicked, the first button will display the first record in the database set. You will also see the Current Record display change to the number 1.

Go To Previous Record

This button will move the displayed record to the one before the currently displayed record. The number in the Current Record display will be diminished by one.

Go To Next Record

This button will move the displayed record to the one after the currently displayed record. The number in the Current Record display will be increased by one.

Go To Last Record

When this button is clicked, the database will display the last record in the database set. You will also see the Current Record display change to the same number as the Total Number of Records.

Create New Record

When clicked this button will generate a new record. The data fields will become blank, and the Total Number of Records will be increase by one.

The PAD Registration Screen - Facility Information

The first tab on the PAD Registration Screen is for Facility Information. The specifics of this tab screen are described below.

This screen contains basic information on the facility. Address 1 is used for the facility’s primary address, with Address 2 typically being used to identify areas such as Suites, Rooms or Floors. In the Zip text box you can enter the full 9 digit zip code if it is known. The phone number should be the general number to the facility.

The Type combo-box is used to categorize the type of facility. Additional types can be added through the database setup form if necessary.

The web site and e-mail text boxes are used to enter the home page for the facility (if there is one available) and a general e-mail address. Specific e-mail addresses for Program Coordinator and Medical Director are provided in their respective areas.

The PAD Registration Screen - Hazard Information

The second tab on the PAD Registration Screen is for Hazard Information. The specifics of this tab screen are described below.

The Hazard tab has a few additional items not seen on the Facility tab. First, you will notice that there is an additional New, Search and Delete buttons, as well as an additional set of database buttons. These buttons are strictly for the Hazard tab. You can have multiple hazards at a facility, so by clicking on the New button on the Hazard tab, you can add as many hazards as you would like. The second set of database buttons allows you to scroll through these hazards.

At the top of the tab is a combo-box labeled Hazard. Here you will find a list of hazards that can be selected. If the hazard is not listed, it can be added through the database setup form. The Date box defaults to the current date, and is used to identify when the hazard was added to the database. The Location area is used to describe where a particular listed hazard is located in the facility.

The PAD Registration Screen - AED Information

The third tab on the PAD Registration Screen is for AED Information. The specifics of this tab screen are described below.

The AED tab is slightly different from the other tabs on the PAD Registration form. This tab has two separate sections, the top section is for the AED device while the bottom section has the electrode information. Each section has its own set of New, Search and Delete buttons as well as a complete set of database buttons. This arrangement allows you to enter in multiple AEDs as well as multiple sets of electrode pads (in the graphic above a total of 2 sets of AED pads have been entered).

AED Information

The top section contains information on each AED device at a facility.

The date box defaults to the current date, and shows when the AED information was entered. The Brand Name combo-box contains a listing of various AED brands (if the brand is not listed, it can be added). The model number and serial number for each AED should be entered into the appropriate box. The location text box should contain a description of where the AED is located at inside the facility.

Electrode Information

The bottom section contains information on each electrode pad set at a facility.

The Brand Name combo-box contains a listing of various electrode brands (if the brand is not listed, it can be added). The model number and serial number for each electrode set should be entered into the appropriate box if the information is available. Every electrode pad comes with a lot number and expiration date, and these should be entered into the appropriate text boxes.

The PAD Registration Screen - Program Coordinator Information

The fourth tab on the PAD Registration Screen is for information on the Program Coordinator for the specific facility. The specifics of this tab screen are described below.

This section allows you to track information about the facility’s program coordinator. The date box will default to the current date. The top section is used to identify the program coordinator and how to contact them. The bottom section is utilized to track the coordinators CPR and AED training. This includes where they were trained, and the issue & expiration dates on their CPR/AED certifications.

The PAD Registration Screen - Medical Director Information

The fifth tab on the PAD Registration Screen is for Medical Director's information. The specifics of this tab screen are described below.

This screen contains contact and license information on the medical director for a particular facility. The date will default to the current date when the entry is made. The remainder of the form is fairly standard.

As there are many facilities that utilize the same physician, you can search to see if the facility’s medical director is already listed. To begin, click on the ‘Search for Existing Director’ button. If the medical director is listed, that information can then be copied into the text fields.

Search for Existing Director

When the ‘Search for Existing Director’ button (located on the Medical Director tab in the Pad Registration form) is clicked, the Program Medical Directors dialog box will be displayed.

This dialog box searches the database for all of the current medical directors, and then list them in alphabetical order. You can scroll through their names, or use the search function in an attempt to locate a specific physician.

Once you have located the physician, all of their information can be transferred to the current facility record. Click on the ‘Transfer’ button to have all of the information appear in the Medical Director tab. When you are done, click on the Close button to return to the Facility form.

Note: None of the information can be changed in the Program Medical Directors dialog box. If the majority of the information is correct but one or two items are not (for example, a different phone and fax number), transfer the information into the Medical Director tab on the Facility form. Once it is in the Facility form, you can then manipulate the data in any fashion.

Once the facility information is entered, you can click on the PAD Application button. This will complete the application process.

The PAD Application Screen - An Overview

The PAD Application Screen is used to record and track a facility’s PAD application. Currently, the default PAD certification period is four years. The PAD Application Screen can track all certification periods, as well as missing items that prevent the application from being approved. Lastly it can print out the Rejection Notice report or the Certification Package.

The top section is used to identify the type of application (Initial or Renewal), the certification period and certification number. The issue date defaults to the current date, and the expiration date defaults to four years from the current date. The certification number is automatically calculated once the Approved check box is marked in the Final Review section. All of these items can be changed from their defaults.

The bottom section identifies if the application has been approved or if a rejection letter has been sent. The approved date defaults to the date when the approved box is checked. The re viewer's name should also be entered.

Application Report Packages

There are two buttons located at the bottom of the Application tab. These reports are used to notify an applicant that either their application has been rejected and the reason(s) why, or to provide them with a complete four year certification package.

Rejection Notice

When a facility has not met all of the requirements for the PAD program, a form letter can be printed and sent to the facility advising them of the problem(s) with their application. To generate this report, click on the ‘Rejection Notice’ button to preview the report, or click on the printer just to the right of the ‘Rejection Notice’ button to send the report directly to the printer.

The Rejection Notice report will indicate the reason(s) why the application has been denied, and what needs to be supplied to complete the application process. The PAD Program Coordinator needs to sign the report prior to being sent off. When this report is generated and sent to the applicant, the Rejection Sent box should be checked.

Certification Package

When a facility has met all of the requirements for the PAD program, a Certification Package needs to be generated and forwarded to the facility. To generate this report, click on the ‘Certification Package’ button to preview the report, or click on the printer just to the right of the ‘Certification Package’ button to send the report directly to the printer.

After clicking on one of the Certification package buttons, a Fax Info dialog box will be displayed. This information is used to print out the CAD Update Information, including the fax cover sheet.

The top of the dialog box is used to identify who should receive the fax. The middle section identifies who is sending the fax. The bottom section can contain any comments pertaining to the fax.

If you need to send the fax to more than one location, multiple recipients and senders can be stored.

The next dialog box allows you to enter names and titles for the Certification Letter and the Certificate.

The top name and title set will appear on both the Certification Letter and the Certificate. The lower name and title set will only appear on the Certificate. As shown above, it is not necessary to have all of the items filled in.

If you provide services for more than one jurisdiction, you can have multiple signature pairs. Whatever pair is currently visible when the 'Close' button is clicked is the pair that will be printed on the certificate and letter.

Once you click on the 'Close' button, a total of three reports will be generated.

The PAD Application Screen - Employees & Payment Screen

The second tab on the PAD Application Screen is used to record information pertaining to the facility’s employees and the payment of the program fee. The specifics of this tab screen are described below.

Employees

The Employees section is used to track how many individuals at a particular location are trained in CPR and the use of the AED, how many individuals the company is expecting to train, and to track the percentage trained to the overall number of employees.

Payment

The Payment section is used to record the license fee and how/when it was paid. The fee currently defaults to $25.00. When the 'Paid' box is checked, it will default to the current date. It will also allow you to select how the fee was paid; Money Order, Check or Credit Card.

The PAD Application Screen - Rejection Status – Missing Items

This screen allows you to identify the reasons an application was rejected. The items checked here will be displayed as checked on the rejection letter. You can also enter any items that is not listed among the check boxes in the 'other' text box.

PAD Database Setup

The database setup section is used to help populate the combo boxes that are used throughout the program. This information should be entered before adding PAD programs into the main application program.

Database Setup Switchboard

The database switchboard is split into two sections; AED Information and Facility Information. On the left are three buttons that will help setup information related to the AED (Manufacturers, AED Brands and Pad Brands) and on the right are two buttons that contain setup information for the facilities (Facility Types and Hazards).

Manufacturers

This screen allows you to enter a manufacturer's address and contact information. You can also record a web site address and e-mail address. This information (the manufacturer's name is the minimum amount of information that is required) needs to be completed prior to entering the AED Brands or Pad Brands.

AED Brands

On this screen you should enter the brand name of the AED, and then select the manufacturer from the drop-down list.

Pad Brands

On this screen you should enter the brand name of the AED Pad, and then select the manufacturer from the drop-down list.

Facility Type

On this screen, enter the various types of facilities you have in your jurisdiction (8 sample types have been provided. You can delete any of these if you do not need them.).

Hazards

On this screen, enter the various types of hazard you have in your jurisdiction (5 sample types have been provided. You can delete any of these if you do not need them.).

Modifying the Program

The program has not been compiled into an Access executable program (mde) file. This was done to allow you to easily modify the program if you desire. In this section we will outline some of the items that you will need to consider prior to making any modifications. As always, it is recommended that you make a copy of the program, and perform the modifications to the copy. Always keep an original copy of the program and data separate from the program files that are under development.

Data Dictionary

In Appendix A you will find the data dictionary for the program. The data dictionary shows all of the various data items, the type of data, and how large the item is. Also included is a table relationship diagram showing how the various tables relate to each other. Please review these items prior to beginning any modifications. Have an understanding of how the program is currently designed to operate, that way your modifications will enhance the operation of the program and not cause undue problems.

Report Modifications

One of the first areas you would probably consider modifying is the reports that come with the program. Simple modifications could include

a.	Replace the generic "Emergency Medical Service" titles with those of your agency.

b.	Replace the graphic with your agency seal.

c.	Replace the generic names and titles with the propers ones from your agency.

As you get use to working with the reports, you will probably want to create your own, to answer the needs of your agency.

Security

The prototype does not have any type of password security. This is by design. It is recommended that this be added prior to utilizing the program in a 'real world' environment. Access offers several methods of securing the database. You can utilize a simple, single password system, or you can set up groups with individual login names and passwords as well as individual program rights.

You should look at how you will be using the program, including the number of people utilizing it, the location of the computer that the program is installed on, use on a network, etc. This will have a major impact on the type of security you should implement. It is not recommended that this program be operated without some type of security function installed and operating.

Another area of security to consider is whether to encrypt your database. If you do encrypt your database, your data will be far more secure than leaving it in an unencrypted state. However, it will also operate more slowly, as the data must be decrypted prior to being displayed. Again, look at your situation and decide what security measures are right for you.

If you are not familiar with setting up security in Access, you can get information in the help file that comes with Access. There are also numerous books on the subject, and more than a few articles on various sites on the Internet.

Program Expansion

As with any program of this type, it is highly unlikely that this program will meet all of your needs. Perhaps you need an additional field that we didn't include, or there is a report that is required by your oversight authority that we didn't develop. Because the program is open source, you have access to the source code without any restrictions. You can modify the program as you see fit, to meet the needs of your agency.

It is recommended that prior to beginning any modifications, that a copy of the back-end data file and the front-end program file be made, and all modifications made to the copy. This will allow you to continue using the original program until you are sure your modifications work as expected. Also, if you make a major mistake, the original data and/or program does not become corrupt, and you loss of information can be kept to a minimum.

We encourage you to make the program your own. That is the beauty of Open Source software, and is the main reason we feel that Open Source software is ideally suited for emergency service agencies.

You can review the full version of the software that is currently under development. These files can be found at the SourceForge web site. The files can be downloaded thought the CVS section. See page 31 for more information on the SourceForge.net web site.

PAD Database Reports

The PAD Tracking Database comes with 11 reports that are designed to assist you in running a PAD program. The Reports' switchboard divides the reports into three basic areas; Facility Reports, AED Pad Reports, and Program Reports.

Report Buttons

The report buttons are slightly different from the standard button that you see throughout the program. It is actually two buttons. On the left is a button that identifies the report in plain text. When this button is clicked, you will receive a preview of the report on the screen. To the right is a button with a picture of a printer. When this is clicked, the report will be sent straight to the printer, and no preview will be seen on the screen. This behavior is consistent throughout the program.

Facility Reports

There are five reports in the Facility section. Here is a brief overview of these reports

Alphabetical Listing

This report provides basic address information on the facility, includes coordinator information and total number of AEDs at the facility. All facilities are listed in alphabetical order.

Grouped By Manufacturer

This report provides basic address information on the facility. Includes coordinator information and total number of AEDs at the facility. Facilities are grouped by the manufacturer of the AED.

Facility Hazards

This report provides basic address information on the facility. Also lists all hazards reported for the facility and their location in the facility.

Coordinator Listing

This report provides information on the PAD program coordinator. It also list each facility that the coordinator is responsible for.

Medical Director Listing

This report provides information on the PAD program medical director. It also list each facility that the medical director is responsible for.

AED Pad Reports

The AED Pad Reports are designed to allow the PAD Program Manager to notify facility program coordinators when their AED pads are due to expire. All of the reports in this section provide the same information; Facility Name, Coordinator Inofrmation, and AED Pad Information. The reports are broken down by time frame until the pads expire, which include;

91 to 180 days,

31 to 90 days,

Next 30 days, and

Expired Pads.

Program Reports

There are two reports in this section. They are designed to help you see how well the PAD Program is operating.

Status Report

This report is designed to show how many PAD applications have been processed, how many trained providers are located in those facilities, and how the AEDs are dispersed through a given area by using the ZIP code and by facility type.

Outstanding Applications

This report offers a listing of PAD applications that have not yet been approved and the reasons. It provides the facility coordinator information, and notes if the rejection letter has been sent.

SourceForge.net

SourceForge.net is the world's largest Open Source software development website, with the largest repository of Open Source code and applications available on the Internet. The PAD Program Management System project is housed on the SourceForge.net site. If you have not been to their site, I would encourage you to go there and see what treasures you can find for you and your agency.

The Access 2000 program that you are currently using is a proof of concept prototype. It was developed to see what would be the best way to go about developing a full scale application dedicated to PAD program management.

The application's source code, current development files, database files, documentation and more can be found at http://sourceforge.net/projects/pad-prg-mgt. We also have a mailing list available, and a feedback system for reporting bugs and requesting features.

If you like what we have been doing with the program, you can make a donation to the project through this web page. If you have programming experience and would like to be a part of this project, you can sign up on the site as well.

If you are interested in PAD Program Management, AEDs in general, or general news on the project, you can visit our home page at http://pad-prg-mgt.sourceforge.net. You can also access links to other web sites that contain information about AEDs and their use in a community PAD Program. You can also get to our program page (see above) from the home page.

Appendices

Appendix A: Glossary

Appendix B: Data Dictionary

Appendix C: GNU General Public License (GPL)

Appendix D: GNU Free Documentation License

Appendix A:

Glossary

Many of the items you see throughout the database are similar in appearance and function. To assist in the use of the database and to offer a quick reference guide, the following glossary has been created. The items listed in the glossary all perform the same way throughout the database. If you are unsure about how an item works, this is a good place to start.

Add Button

Any time this button is visible, you can add a new record to the database. Clicking on the button will clear all of the data entry fields so a new record can be entered. The cursor should become visible in the first data entry box.

See Also

Navigation Buttons

Check Box

Check boxes are used in the database to indicate if a particular item is true of false. If a check is present in the box, it would indicate the item is true. If no check is present, then the item is false. To change the status of the check box, place the mouse pointer over the box and single-click the left mouse button. If the box was empty, it should now display a check mark. It the box originally displayed a check mark, the box should be empty.

Close Button

This button will close the current form that is being displayed. Clicking on the ‘X’ button in the upper right corner of the form will also close the form.

Delete Button

This button will delete the currently displayed record. Once the selection has been made, the dialog box listed below will appear.

If you do not wish to have the record deleted, select ‘No’ otherwise click ‘Yes’ and the record will be deleted from the database table.

Navigation Buttons

The navigation buttons are located at the bottom of the form. These buttons allow you to move back and forth through the database records. The button on the far left will move you to the first record in the database. The button next to it will move to the previous record.

The window between the buttons indicates the current record number. The first button to the right of this window moves to the next record. The second button moves to the last record in the database. The last button allows you to enter in a new record. The numbers to the right of the last button show how many total records there are in the database.

Report Button

When a report is available, you can chose to preview the report or send the report directly to the printer. The left button (usually has the name of the report displayed on it) when clicked will display the report for you to review prior to printing. If you click on the small print button on the right, the report will be sent directly to the printer without being previewed.

Note: Some reports can be lengthy, and can result in numerous pages of wasted material if printed directly to the printer without previewing the report first.

Search Button

This button will allow you to search for specific data within the database. When you click on this button, the dialog box displayed below will appear.

There are several options available from this dialog box.

Find What	Enter the information you are looking for, such as an incident number, name, title, etc. You can also use wildcard characters (See Wildcard Characters further on in the glossary for a full definition of their use).

Search	There are three options to chose from here. You can search ‘All’ (the entire database table), ‘Up’ (from the current record back to the beginning of the database table) or ‘Down’ (from the current record forward to the beginning of the database table).

Match	There are three options in this section. You can match ‘Any Part of Field’ (“berg” finds Bergen and Heidelberg), ‘Match Whole Field’ (“London” finds London but not Londonberry), or ‘Start of Field’ (“berg” finds Bergen but not Heidelberg)

Match Case	When checked, the results will only be those entries that match the same patter of upper and lower case as the text you specified in the ‘Find What’ box.

Search Fields	Select to find data based on its display format (a date stored as

As Formatted	the number 1/5/92 but displayed as 05-Jan-92). Searching this way is usually slowest. Clear the check box to find data based on its value

Search Only	When selected, it will search through all records in the current

Current Field	field only. This is usually quicker. Clear the check box to search through all of the records.

Find First	Finds the first occurrence of the search string in the table

Find Next	Searches for the next instance of the text you specified in the Find What box.

Close	Closes the dialog box

Wildcard Characters

You use wildcard characters as placeholders for other characters when you are specifying a value you want to find and you:

Know only part of the value.

Want to find values that start with a specific letter or match a certain pattern.

You can use the following characters in the Find and Replace dialog boxes, or in queries, commands, and expressions, to find such things as field values, records, or file names.

Character	Usage Example

*	Matches any number of characters. It can be used as the first or last character in the character string.

wh* finds what, white, and why

?	Matches any single alphabetic character.

B?ll finds ball, bell, and bill

[ ]	Matches any single character within the brackets.

B[ae]ll finds ball and bell but not bill

!	Matches any character not in the brackets.

b[!ae]ll finds bill and bull but not bell

-	Matches any one of a range of characters. You must specify the range in	ascending order (A to Z, not Z to A).

b[a-c]d finds bad, bbd, and bcd

#	Matches any single numeric character.

1#3 finds 103, 113, 123

Notes

Wildcard characters are meant to be used with text data types, although you can sometimes use them successfully with other data types, such as dates, if you don't change the Regional Settings properties for these data types.

When using wildcard characters to search for an asterisk (*), question mark (?), number sign (#), opening bracket ([), or hyphen (-), you must enclose the item you're searching for in brackets. For example, to search for a question mark, type [?] in the Find dialog box. If you're searching for a hyphen and other characters simultaneously, place the hyphen before or after all the other characters inside the brackets. (However, if you have an exclamation point (!) after the opening bracket, place the hyphen after the exclamation point.) If you're searching for an exclamation point (!) or closing bracket (]), you don't need to enclose it in brackets.

You can't search for the opening and closing brackets ([ ]) together because Microsoft Access interprets this combination as a zero-length string.

Appendix B

Data Dictionary

Lookup Tables

Source Table Name: lkupAEDBrand
Name	Type	Size
AEDBrandRecord	Long Integer	4
AEDBrandText	Text	150
ManufacturerRecord	Long Integer	4

Source Table Name: lkupCreditCardCompany
Name	Type	Size
CreditRecord	Long Integer	4
CreditCardCompany	Text	50

Source Table Name: lkupFacilityType
Name	Type	Size
FacilityTypeCode	Long Integer	4
FacilityTypeText	Text	150

Source Table Name: lkupGPL
Name	Type	Size
ID	Long Integer	4
GPL	Memo	----

Source Table Name: lkupHazards
Name	Type	Size
HazardTypeCode	Long Integer	4
HazardTypeText	Text	150

Source Table Name: lkupManufacturer
Name	Type	Size
ManufacturerRecord	Long Integer	4
Manufacturer	Text	50
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
Phone	Text	15
Fax	Text	15
WebSite	Text	250
Email	Text	250

Source Table Name: lkupPadBrand
Name	Type	Size
PadBrandRecord	Long Integer	4
PadBrandText	Text	150
ManufactuerRecord	Long Integer	4

Source Table Name: lkupStates
Name	Type	Size
State Name	Text	20
Abbreviation	Text	2

Data Tables

Source Table Name: tblAED
Name	Type	Size
AEDRecord	Long Integer	4
FacilityRecord	Long Integer	4
Date	Date/Time	8
Brand	Long Integer	4
ModelNumber	Text	50
SerialNumber	Text	50
Location	Text	250

Source Table Name: tblApplication
Name	Type	Size
ApplicationRecord	Long Integer	4
FacilityRecord	Long Integer	4
Type	Byte	1
Date	Date/Time	8
CertificationNumber	Text	255
ExpirationDate	Date/Time	8
Approved	Yes/No	1
RejectionAddress	Yes/No	1
RejectionTraining	Yes/No	1
RejectionCoordinatorSignature	Yes/No	1
RejectionCoordinatorNotCurrent	Yes/No	1
RejectionMedDirectorSignature	Yes/No	1
RejectionMedDirectorLicense	Yes/No	1
RejectionMedDirectorAddress	Yes/No	1
RejectionAEDBrand	Yes/No	1
RejectionAEDModel	Yes/No	1
RejectionAEDSerial	Yes/No	1
RejectionAEDLocation	Yes/No	1
RejectionElectrodeBrand	Yes/No	1
RejectionElectrodeManufacturer	Yes/No	1
RejectionElectrodeSerialNumber	Yes/No	1
RejectionElectrodeExpDate	Yes/No	1
RejectionPayment	Yes/No	1
RejectionOther	Text	250
RejectionSent	Yes/No	1
Reviewer	Text	250
ReviewDate	Date/Time	8
NumberEmployees	Long Integer	4
NumberEmployeesTrained	Long Integer	4
NumberEmployeesToBeTrained	Long Integer	4
Fee	Currency	8
Paid	Yes/No	1
PaymentReceived	Date/Time	8
PaymentType	Byte	1
CheckNumber	Text	50
CreditCardCompany	Long Integer	4
CreditCardNumber	Text	50
CreditCardExpDate	Date/Time	8
CreditCardName	Text	50

Source Table Name: tblCADFax
Name	Type	Size
CADRecord	Long Integer	4
FaxTo	Text	50
FaxNumber	Text	15
SentBy	Text	50
SendersPhone	Text	15

Source Table Name: tblCoordinator
Name	Type	Size
CoordinatorRecord	Long Integer	4
FacilityRecord	Long Integer	4
Date	Date/Time	8
Name	Text	50
Phone	Text	15
Fax	Text	15
Pager	Text	15
Email	Text	250
TrainingProgram	Text	250
TrainingCenterAddress	Text	250
CompletionDate	Date/Time	8
ExpirationDate	Date/Time	8

Source Table Name: tblDirector
Name	Type	Size
DirectorRecord	Long Integer	4
FacilityRecord	Long Integer	4
Date	Date/Time	8
Name	Text	50
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
Phone	Text	15
Fax	Text	15
Pager	Text	15
Email	Text	250
LicenseNumber	Text	250

Source Table Name: tblFacilty
Name	Type	Size
FacilityRecord	Long Integer	4
Name	Text	50
Phone	Text	15
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
FacilityType	Long Integer	4
WebSite	Text	250
Email	Text	250

Source Table Name: tblHazards
Name	Type	Size
HazardRecord	Long Integer	4
FacilityRecord	Long Integer	4
Date	Date/Time	8
HazardTypeCode	Long Int	4
Location	Text	250

Source Table Name: tblPads
Name	Type	Size
PadRecord	Long Integer	4
FacilityRecord	Long Integer	4
PadBrandRecord	Long Integer	4
PadModelNumber	Text	50
PadSerialNumber	Text	50
PadLotNumber	Text	50
PadExpirationDate	Date/Time	8
Source Table Name: tblSignatureBlocks
Name	Type	Size
Record	Long Integer	4
LeftName	Text	250
LeftTitle1	Text	250
LeftTitle2	Text	250
LeftTitle3	Text	250
RightName	Text	250
RightTitle1	Text	250
RightTitle2	Text	250
RightTitle3	Text	250

Appendix C

GNU GENERAL PUBLIC LICENSE

Version 2, June 1991

Copyright (C) 1989, 1991 Free Software Foundation, Inc.

59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

Everyone is permitted to copy and distribute verbatim copies

of this license document, but changing it is not allowed.

Preamble

The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public License is intended to guarantee your freedom to share and change free

software--to make sure the software is free for all its users. This General Public License applies to most of the Free Software Foundation's software and to any other program whose authors commit to using it. (Some other Free Software Foundation software is covered by the GNU Library General Public License instead.) You can apply it to your programs, too.

When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things.

To protect your rights, we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights. These restrictions translate to certain responsibilities for you if you distribute copies of the software, or if you modify it.

For example, if you distribute copies of such a program, whether gratis or for a fee, you must give the recipients all the rights that you have. You must make sure that they, too, receive or can get the source code. And you must show them these terms so they know their rights.

We protect your rights with two steps:

(1) copyright the software, and

(2) offer you this license which gives you legal permission to copy, distribute and/or modify the software.

Also, for each author's protection and ours, we want to make certain that everyone understands that there is no warranty for this free software. If the software is modified by someone else and passed on, we want its recipients to know that what they have is not the original, so that any problems introduced by others will not reflect on the original authors' reputations.

Finally, any free program is threatened constantly by software patents. We wish to avoid the danger that redistributors of a free program will individually obtain patent licenses, in effect making the program proprietary. To prevent this, we have made it clear that any patent must be licensed for everyone's free use or not licensed at all.

The precise terms and conditions for copying, distribution and modification follow.

GNU GENERAL PUBLIC LICENSE

TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION

0. This License applies to any program or other work which contains a notice placed by the copyright holder saying it may be distributed under the terms of this General Public License. The "Program", below,

refers to any such program or work, and a "work based on the Program" means either the Program or any derivative work under copyright law: that is to say, a work containing the Program or a portion of it, either verbatim or with modifications and/or translated into another language. (Hereinafter, translation is included without limitation in the term "modification".) Each licensee is addressed as "you".

Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running the Program is not restricted, and the output from the Program is covered only if its contents constitute a work based on the Program (independent of having been made by running the Program). Whether that is true depends on what the Program does.

1. You may copy and distribute verbatim copies of the Program's source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and give any other recipients of the Program a copy of this License along with the Program.

You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee.

2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions:

a) You must cause the modified files to carry prominent notices stating that you changed the files and the date of any change.

b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License.

c) If the modified program normally reads commands interactively when run, you must cause it, when started running for such interactive use in the most ordinary way, to print or display an announcement including an appropriate copyright notice and a notice that there is no warranty (or else, saying that you provide a warranty) and that users may redistribute the program under these conditions, and telling the user how to view a copy of this License. (Exception: if the Program itself is interactive but does not normally print such an announcement, your work based on the Program is not required to print an announcement.)

These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Program, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it.

Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Program.

In addition, mere aggregation of another work not based on the Program with the Program (or with a work based on the Program) on a volume of a storage or distribution medium does not bring the other work under

the scope of this License.

3. You may copy and distribute the Program (or a work based on it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you also do one of the following:

a) Accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or,

b) Accompany it with a written offer, valid for at least three years, to give any third party, for a charge no more than your cost of physically performing source distribution, a complete machine-readable copy of the corresponding source code, to be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or,

c) Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only for noncommercial distribution and only if you received the program in object code or executable form with such an offer, in accord with Subsection b above.)

The source code for a work means the preferred form of the work for making modifications to it. For an executable work, complete source code means all the source code for all modules it contains, plus any

associated interface definition files, plus the scripts used to control compilation and installation of the executable. However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable.

If distribution of executable or object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place counts as distribution of the source code, even though third parties are not compelled to copy the source along with the object code.

4. You may not copy, modify, sublicense, or distribute the Program except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense or distribute the Program is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance.

5. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Program or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Program (or any work based on the Program), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Program or works based on it.

6. Each time you redistribute the Program (or any work based on the Program), the recipient automatically receives a license from the original licensor to copy, distribute or modify the Program subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties to this License.

7. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Program at all. For example, if a patent license would not permit royalty-free redistribution of the Program by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to

refrain entirely from distribution of the Program.

If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply and the section as a whole is intended to apply in other circumstances.

It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system, which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice.

This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License.

8. If the distribution and/or use of the Program is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Program under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License.

9. The Free Software Foundation may publish revised and/or new versions of the General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns.

Each version is given a distinguishing version number. If the Program specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Program does not specify a version number of this License, you may choose any version ever published by the Free Software Foundation.

10. If you wish to incorporate parts of the Program into other free programs whose distribution conditions are different, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally.

NO WARRANTY

11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.

12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

END OF TERMS AND CONDITIONS

How to Apply These Terms to Your New Programs

If you develop a new program, and you want it to be of the greatest possible use to the public, the best way to achieve this is to make it free software which everyone can redistribute and change under these terms.

To do so, attach the following notices to the program. It is safest to attach them to the start of each source file to most effectively convey the exclusion of warranty; and each file should have at least the "copyright" line and a pointer to where the full notice is found.

<one line to give the program's name and a brief idea of what it does.>

Copyright (C) <year> <name of author>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

Also add information on how to contact you by electronic and paper mail.

If the program is interactive, make it output a short notice like this when it starts in an interactive mode:

Gnomovision version 69, Copyright (C) year name of author

Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'. This is free software, and you are welcome to redistribute it under certain conditions; type `show c' for details.

The hypothetical commands `show w' and `show c' should show the appropriate parts of the General Public License. Of course, the commands you use may be called something other than `show w' and `show c'; they could even be mouse-clicks or menu items--whatever suits your program.

You should also get your employer (if you work as a programmer) or your school, if any, to sign a "copyright disclaimer" for the program, if necessary. Here is a sample; alter the names:

Yoyodyne, Inc., hereby disclaims all copyright interest in the program

`Gnomovision' (which makes passes at compilers) written by James Hacker.

<signature of Ty Coon>, 1 April 1989

Ty Coon, President of Vice

This General Public License does not permit incorporating your program into proprietary programs. If your program is a subroutine library, you may consider it more useful to permit linking proprietary applications with the library. If this is what you want to do, use the GNU Library General Public License instead of this License.

Appendix D

GNU Free Documentation License

Version 1.2, November 2002

Copyright (C) 2000,2001,2002 Free Software Foundation, Inc.

59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

Everyone is permitted to copy and distribute verbatim copies

of this license document, but changing it is not allowed.

0. PREAMBLE

The purpose of this License is to make a manual, textbook, or other functional and useful document "free" in the sense of freedom: to assure everyone the effective freedom to copy and redistribute it, with or without modifying it, either commercially or noncommercially. Secondarily, this License preserves for the author and publisher a way to get credit for their work, while not being considered responsible for modifications made by others.

This License is a kind of "copyleft", which means that derivative works of the document must themselves be free in the same sense. It complements the GNU General Public License, which is a copyleft license designed for free software.

We have designed this License in order to use it for manuals for free software, because free software needs free documentation: a free program should come with manuals providing the same freedoms that the software does. But this License is not limited to software manuals; it can be used for any textual work, regardless of subject matter or whether it is published as a printed book. We recommend this License principally for works whose purpose is instruction or reference.

1. APPLICABILITY AND DEFINITIONS

This License applies to any manual or other work, in any medium, that contains a notice placed by the copyright holder saying it can be distributed under the terms of this License. Such a notice grants a world-wide, royalty-free license, unlimited in duration, to use that work under the conditions stated herein. The "Document", below, refers to any such manual or work. Any member of the public is a licensee, and is addressed as "you". You accept the license if you copy, modify or distribute the work in a way requiring permission under copyright law.

A "Modified Version" of the Document means any work containing the Document or a portion of it, either copied verbatim, or with modifications and/or translated into another language.

A "Secondary Section" is a named appendix or a front-matter section of the Document that deals exclusively with the relationship of the publishers or authors of the Document to the Document's overall subject (or to related matters) and contains nothing that could fall directly within that overall subject. (Thus, if the Document is in part a textbook of mathematics, a Secondary Section may not explain any mathematics.) The relationship could be a matter of historical connection with the subject or with related matters, or of legal, commercial, philosophical, ethical or political position regarding them.

The "Invariant Sections" are certain Secondary Sections whose titles are designated, as being those of Invariant Sections, in the notice that says that the Document is released under this License. If a section does not fit the above definition of Secondary then it is not allowed to be designated as Invariant. The Document may contain zero Invariant Sections. If the Document does not identify any Invariant Sections then there are none.

The "Cover Texts" are certain short passages of text that are listed, as Front-Cover Texts or Back-Cover Texts, in the notice that says that the Document is released under this License. A Front-Cover Text may

be at most 5 words, and a Back-Cover Text may be at most 25 words.

A "Transparent" copy of the Document means a machine-readable copy, represented in a format whose specification is available to the general public, that is suitable for revising the document straightforwardly with generic text editors or (for images composed of pixels) generic paint programs or (for drawings) some widely available drawing editor, and that is suitable for input to text formatters or for automatic translation to a variety of formats suitable for input to text formatters. A copy made in an otherwise Transparent file

format whose markup, or absence of markup, has been arranged to thwart or discourage subsequent modification by readers is not Transparent. An image format is not Transparent if used for any substantial amount of text. A copy that is not "Transparent" is called "Opaque".

Examples of suitable formats for Transparent copies include plain ASCII without markup, Texinfo input format, LaTeX input format, SGML or XML using a publicly available DTD, and standard-conforming simple HTML, PostScript or PDF designed for human modification. Examples of transparent image formats include PNG, XCF and JPG. Opaque formats include proprietary formats that can be read and edited only by proprietary word processors, SGML or XML for which the DTD and/or processing tools are not generally available, and the machine-generated HTML, PostScript or PDF produced by some word

processors for output purposes only.

The "Title Page" means, for a printed book, the title page itself, plus such following pages as are needed to hold, legibly, the material this License requires to appear in the title page. For works in formats which do not have any title page as such, "Title Page" means the text near the most prominent appearance of the work's title, preceding the beginning of the body of the text.

A section "Entitled XYZ" means a named subunit of the Document whose title either is precisely XYZ or contains XYZ in parentheses following text that translates XYZ in another language. (Here XYZ stands for a specific section name mentioned below, such as "Acknowledgements", "Dedications", "Endorsements", or "History".) To "Preserve the Title" of such a section when you modify the Document means that it remains a section "Entitled XYZ" according to this definition.

The Document may include Warranty Disclaimers next to the notice which states that this License applies to the Document. These Warranty Disclaimers are considered to be included by reference in this License, but only as regards disclaiming warranties: any other implication that these Warranty Disclaimers may have is void and has no effect on the meaning of this License.

2. VERBATIM COPYING

You may copy and distribute the Document in any medium, either commercially or noncommercially, provided that this License, the copyright notices, and the license notice saying this License applies to the Document are reproduced in all copies, and that you add no other conditions whatsoever to those of this License. You may not use technical measures to obstruct or control the reading or further copying of the copies you make or distribute. However, you may accept compensation in exchange for copies. If you distribute a large enough number of copies you must also follow the conditions in section 3. You may also lend copies, under the same conditions stated above, and you may publicly display copies.

3. COPYING IN QUANTITY

If you publish printed copies (or copies in media that commonly have printed covers) of the Document, numbering more than 100, and the Document's license notice requires Cover Texts, you must enclose the copies in covers that carry, clearly and legibly, all these Cover Texts: Front-Cover Texts on the front cover, and Back-Cover Texts on the back cover. Both covers must also clearly and legibly identify you as the publisher of these copies. The front cover must present the full title with all words of the title equally prominent and visible. You may add other material on the covers in addition. Copying with changes limited to the covers, as long as they preserve the title of the Document and satisfy these conditions, can be treated

as verbatim copying in other respects.

If the required texts for either cover are too voluminous to fit legibly, you should put the first ones listed (as many as fit reasonably) on the actual cover, and continue the rest onto adjacent pages.

If you publish or distribute Opaque copies of the Document numbering more than 100, you must either include a machine-readable Transparent copy along with each Opaque copy, or state in or with each Opaque copy a computer-network location from which the general network-using public has access to download using public-standard network protocols a complete Transparent copy of the Document, free of added material. If you use the latter option, you must take reasonably prudent steps, when you begin distribution of Opaque copies in quantity, to ensure that this Transparent copy will remain thus accessible at the stated

location until at least one year after the last time you distribute an Opaque copy (directly or through your agents or retailers) of that edition to the public.

It is requested, but not required, that you contact the authors of the Document well before redistributing any large number of copies, to give them a chance to provide you with an updated version of the Document.

4. MODIFICATIONS

You may copy and distribute a Modified Version of the Document under the conditions of sections 2 and 3 above, provided that you release the Modified Version under precisely this License, with the Modified Version filling the role of the Document, thus licensing distribution and modification of the Modified Version to whoever possesses a copy of it. In addition, you must do these things in the Modified Version:

A. Use in the Title Page (and on the covers, if any) a title distinct from that of the Document, and from those of previous versions (which should, if there were any, be listed in the History section of the Document). You may use the same title as a previous version if the original publisher of that version gives permission.

B. List on the Title Page, as authors, one or more persons or entities responsible for authorship of the modifications in the Modified Version, together with at least five of the principal authors of the Document (all of its principal authors, if it has fewer than five), unless they release you from this requirement.

C. State on the Title page the name of the publisher of the Modified Version, as the publisher.

D. Preserve all the copyright notices of the Document.

E. Add an appropriate copyright notice for your modifications adjacent to the other copyright notices.

F. Include, immediately after the copyright notices, a license notice giving the public permission to use the Modified Version under the terms of this License, in the form shown in the Addendum below.

G. Preserve in that license notice the full lists of Invariant Sections and required Cover Texts given in the Document's license notice.

H. Include an unaltered copy of this License.

I. Preserve the section Entitled "History", Preserve its Title, and add to it an item stating at least the title, year, new authors, and publisher of the Modified Version as given on the Title Page. If there is no section Entitled "History" in the Document, create one stating the title, year, authors, and publisher of the Document as given on its Title Page, then add an item describing the Modified Version as stated in the previous sentence.

J. Preserve the network location, if any, given in the Document for public access to a Transparent copy of the Document, and likewise the network locations given in the Document for previous versions it was based on. These may be placed in the "History" section. You may omit a network location for a work that was published at least four years before the Document itself, or if the original publisher of the version it refers to gives permission.

K. For any section Entitled "Acknowledgments" or "Dedications", Preserve the Title of the section, and preserve in the section all the substance and tone of each of the contributor acknowledgments and/or dedications given therein.

L. Preserve all the Invariant Sections of the Document, unaltered in their text and in their titles. Section numbers or the equivalent are not considered part of the section titles.

M. Delete any section Entitled "Endorsements". Such a section may not be included in the Modified Version.

N. Do not retitle any existing section to be Entitled "Endorsements" or to conflict in title with any Invariant Section.

O. Preserve any Warranty Disclaimers.

If the Modified Version includes new front-matter sections or appendices that qualify as Secondary Sections and contain no material copied from the Document, you may at your option designate some or all of these sections as invariant. To do this, add their titles to the list of Invariant Sections in the Modified Version's license notice. These titles must be distinct from any other section titles.

You may add a section Entitled "Endorsements", provided it contains nothing but endorsements of your Modified Version by various parties--for example, statements of peer review or that the text has been approved by an organization as the authoritative definition of a standard.

You may add a passage of up to five words as a Front-Cover Text, and a passage of up to 25 words as a Back-Cover Text, to the end of the list of Cover Texts in the Modified Version. Only one passage of

Front-Cover Text and one of Back-Cover Text may be added by (or through arrangements made by) any one entity. If the Document already includes a cover text for the same cover, previously added by you or

by arrangement made by the same entity you are acting on behalf of, you may not add another; but you may replace the old one, on explicit permission from the previous publisher that added the old one.

The author(s) and publisher(s) of the Document do not by this License give permission to use their names for publicity for or to assert or imply endorsement of any Modified Version.

5. COMBINING DOCUMENTS

You may combine the Document with other documents released under this License, under the terms defined in section 4 above for modified versions, provided that you include in the combination all of the Invariant Sections of all of the original documents, unmodified, and list them all as Invariant Sections of your combined work in its license notice, and that you preserve all their Warranty Disclaimers.

The combined work need only contain one copy of this License, and multiple identical Invariant Sections may be replaced with a single copy. If there are multiple Invariant Sections with the same name but different contents, make the title of each such section unique by adding at the end of it, in parentheses, the name of the original author or publisher of that section if known, or else a unique number. Make the same adjustment to the section titles in the list of Invariant Sections in the license notice of the combined work.

In the combination, you must combine any sections Entitled "History" in the various original documents, forming one section Entitled "History"; likewise combine any sections Entitled "Acknowledgments", and any sections Entitled "Dedications". You must delete all sections Entitled "Endorsements".

6. COLLECTIONS OF DOCUMENTS

You may make a collection consisting of the Document and other documents released under this License, and replace the individual copies of this License in the various documents with a single copy that is included in the collection, provided that you follow the rules of this License for verbatim copying of each of the documents in all other respects.

You may extract a single document from such a collection, and distribute it individually under this License, provided you insert a copy of this License into the extracted document, and follow this License in all other respects regarding verbatim copying of that document.

7. AGGREGATION WITH INDEPENDENT WORKS

A compilation of the Document or its derivatives with other separate and independent documents or works, in or on a volume of a storage or distribution medium, is called an "aggregate" if the copyright resulting from the compilation is not used to limit the legal rights of the compilation's users beyond what the individual works permit. When the Document is included in an aggregate, this License does not apply to the other works in the aggregate which are not themselves derivative works of the Document.

If the Cover Text requirement of section 3 is applicable to these copies of the Document, then if the Document is less than one half of the entire aggregate, the Document's Cover Texts may be placed on covers that bracket the Document within the aggregate, or the electronic equivalent of covers if the Document is in electronic form. Otherwise they must appear on printed covers that bracket the whole

aggregate.

8. TRANSLATION

Translation is considered a kind of modification, so you may distribute translations of the Document under the terms of section 4. Replacing Invariant Sections with translations requires special permission from their copyright holders, but you may include translations of some or all Invariant Sections in addition to the original versions of these Invariant Sections. You may include a translation of this License, and all the license notices in the Document, and any Warranty Disclaimers, provided that you also include the original English version of this License and the original versions of those notices and disclaimers. In case of a disagreement between the translation and the original version of this License or a notice or disclaimer, the original version will prevail.

If a section in the Document is Entitled "Acknowledgments", "Dedications", or "History", the requirement (section 4) to Preserve its Title (section 1) will typically require changing the actual title.

9. TERMINATION

You may not copy, modify, sublicense, or distribute the Document except as expressly provided for under this License. Any other attempt to copy, modify, sublicense or distribute the Document is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance.

10. FUTURE REVISIONS OF THIS LICENSE

The Free Software Foundation may publish new, revised versions of the GNU Free Documentation License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. See http://www.gnu.org/copyleft/.

Each version of the License is given a distinguishing version number. If the Document specifies that a particular numbered version of this License "or any later version" applies to it, you have the option of

following the terms and conditions either of that specified version or of any later version that has been published (not as a draft) by the Free Software Foundation. If the Document does not specify a version number of this License, you may choose any version ever published (not as a draft) by the Free Software Foundation.

ADDENDUM: How to use this License for your documents

To use this License in a document you have written, include a copy of the License in the document and put the following copyright and license notices just after the title page:

Copyright (c) YEAR YOUR NAME.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled "GNU Free Documentation License".

If you have Invariant Sections, Front-Cover Texts and Back-Cover Texts, replace the "with...Texts." line with this:

with the Invariant Sections being LIST THEIR TITLES, with the Front-Cover Texts being LIST, and with the Back-Cover Texts being LIST.

If you have Invariant Sections without Cover Texts, or some other combination of the three, merge those two alternatives to suit the situation.

If your document contains nontrivial examples of program code, we recommend releasing these examples in parallel under your choice of free software license, such as the GNU General Public License, to permit their use in free software.

57

PAD Registration & Tracking Database - Prototype - User's Guide

This is the user's guide for the PAD Registration & Tracking Database - Prototype. The prototype was developed in Access 2000. The User's Guide contains the complete data dictionary.

Robert Austin

2004-10-31T20:12:04